from sqlalchemy import Column, Integer, String, Text, Boolean, Date, DateTime, Time, BigInteger, Numeric, Float
from core.base.orm_model import Base


class CustomerInfo(Base):
    __tablename__ = "customer_info"

    id = Column(BigInteger, primary_key=True, nullable=False, comment="主键ID")
    customer_code = Column(String(50), comment="客户编码")
    customer_name = Column(String(100), nullable=False, comment="客户名称")
    business_type = Column(String(50), comment="商机类别")
    division = Column(String(50), comment="事业部")
    category = Column(String(50), comment="类别")
    industry_type = Column(String(50), comment="行业别")
    strategy_industry = Column(String(50), comment="策略行业")
    customer_source = Column(String(50), comment="客户来源")
    salesperson = Column(String(50), comment="业务员")
    customer_product = Column(Text, comment="客户产品")
    informatization_status = Column(Text, comment="客户信息化现状")
    scale = Column(String(50), comment="营业规模")
    acpid = Column(String(50), comment="ACPID")
    address = Column(String(255), comment="地址")
    employee_count = Column(Integer, comment="员工人数")
    company_nature = Column(String(50), comment="企业性质")
    capital = Column(Numeric, comment="资本额")
    website = Column(String(255), comment="公司网址")
    created_by = Column(String(50), comment="创建人")
    create_time = Column(DateTime, comment="创建时间")
    updated_by = Column(String(50), comment="更新人")
    update_time = Column(DateTime, comment="更新时间")
